<?php
  // EQuipment LOcation (where is equipment placed when in use)
  require_once dirname(__FILE__)."/../purin2/alter/alter.php";

  // drop or clear
  puSql("drop table eqlo");
  puDelete("delete from eqlo");

  // create table
  puSql("
  create table eqlo (
    i_eqlo integer auto_increment not null, -- serial
    v_eqlo varchar(50) character set utf8 collate utf8_general_ci not null,            -- name of the equipment location
    primary key (i_eqlo)
  )");

  // index
  puSql("create unique index p_eqlo_1 on eqlo (i_eqlo)");
  puSql("create unique index s_eqlo_1 on eqlo (v_eqlo)");
?>